﻿using System.Collections.Generic;

namespace Citi.PTSConsolidation.Domain
{
    public class ApplicationPercentage
    {
        #region Mappings

        public static readonly Dictionary<string, string> ExcelColumnMappings = new Dictionary<string, string> { 
                { "[Period Year]", "PeriodYear" },
                { "[Project Id]", "ProjectId" } ,
                { "[Project Application ID]", "ApplicationId" },
                { "[Project Application Pct]", "Percentage" }
            };

        #endregion

        #region Querystrings

        public const string ExcelQueryString = @"Select [Period Year], [Project Id], [Project Application ID], [Project Application Pct] from [{0}]";

        public static string GetQueryDuplicateData(int year)
        {
            return string.Format("DELETE FROM ApplicationPercentage WHERE PeriodYear IN ({0}, {1}, {2})", year - 1, year, year + 1);
        }

        #endregion
    }
}
